﻿CREATE TABLE [dbo].[Parliamentarians] (
    [Id]                                                    NVARCHAR (100) NOT NULL,
    [FirstName]                                             NVARCHAR (MAX) NOT NULL,
    [Surname]                                               NVARCHAR (MAX) NOT NULL,
    [Party]                                                 NVARCHAR (MAX) NOT NULL,
    [Electorate]                                            NVARCHAR (MAX) NOT NULL,
    [State]                                                 NVARCHAR (MAX) NOT NULL,
    [Current]                                               BIT            NOT NULL,
    [Salutation]                                            NVARCHAR (MAX) NOT NULL,
    [ImageLink]                                             NVARCHAR (MAX) NOT NULL,
    [ParliamentaryService]                                  NVARCHAR (MAX) NULL,
    [ParliamentaryPositions]                                NVARCHAR (MAX) NULL,
    [MinisterialAppointments]                               NVARCHAR (MAX) NULL,
    [CommitteeService]                                      NVARCHAR (MAX) NULL,
    [ConferencesDelegationsVisits]                          NVARCHAR (MAX) NULL,
    [ParliamentaryPartyPositions]                           NVARCHAR (MAX) NULL,
    [PartyPositions]                                        NVARCHAR (MAX) NULL,
    [Personal]                                              NVARCHAR (MAX) NULL,
    [PreParliament]                                         NVARCHAR (MAX) NULL,
    [Publications]                                          NVARCHAR (MAX) NULL,
    [ElectorateDescription]                                 NVARCHAR (MAX) NOT NULL,
    [LocalGovtService]                                      NVARCHAR (MAX) NULL,
    [ParliamentaryAppointments]                             NVARCHAR (MAX) NULL,
    [Chamber]                                               NVARCHAR (MAX) NOT NULL,
    [MilitaryService]                                       NVARCHAR (MAX) NULL,
    [GenericSearchResultParliamentarian_Parliamentarian_Id] NVARCHAR (100) NOT NULL
);























